USE [GradingSystemDb]
SET IDENTITY_INSERT [dbo].[Employees] ON

INSERT [dbo].[Employees] ([EmployeeId],[EmployeeTypeId],[CourseId],[FirstName],[MiddleName],[LastName],[HomeAddress],[ContactNumber],[EmailAddress],[EmployeeCode],[Year],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (1,1,1,'Mark Ryan','Villagracia','Alot','Bacoor, Cavite 4102','09175869149','mark.ryan.alot@sissat.com','2004180029',0,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Employees] ([EmployeeId],[EmployeeTypeId],[CourseId],[FirstName],[MiddleName],[LastName],[HomeAddress],[ContactNumber],[EmailAddress],[EmployeeCode],[Year],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (2,2,1,'Edna','Villagracia','Rentutar','Las Pinas','09158888350','edna.rentutar@sissat.com','2004180030',0,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Employees] ([EmployeeId],[EmployeeTypeId],[CourseId],[FirstName],[MiddleName],[LastName],[HomeAddress],[ContactNumber],[EmailAddress],[EmployeeCode],[Year],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (3,3,1,'Elma','Manas','Villagracia','Bacoor, Cavite 4102','09174924016','elma.alot@sissat.com','2004180031',0,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Employees] ([EmployeeId],[EmployeeTypeId],[CourseId],[FirstName],[MiddleName],[LastName],[HomeAddress],[ContactNumber],[EmailAddress],[EmployeeCode],[Year],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (4,3,1,'Elenita','Alot','Voluntad','Bacoor, Cavite 4102','','elenita.voluntad@sissat.com','2004180032',0,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Employees] ([EmployeeId],[EmployeeTypeId],[CourseId],[FirstName],[MiddleName],[LastName],[HomeAddress],[ContactNumber],[EmailAddress],[EmployeeCode],[Year],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (5,4,2,'Rhalf','Enriquez','Alot','Bacoor, Cavite 4102','09052446363','rhalf.alot@sissat.com','2008180029',1,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Employees] ([EmployeeId],[EmployeeTypeId],[CourseId],[FirstName],[MiddleName],[LastName],[HomeAddress],[ContactNumber],[EmailAddress],[EmployeeCode],[Year],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (6,4,3,'Jesus','Alot','Voluntad','Bacoor, Cavite 4102','09159372005','jesus.voluntad@sissat.com','2008180030',2,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Employees] ([EmployeeId],[EmployeeTypeId],[CourseId],[FirstName],[MiddleName],[LastName],[HomeAddress],[ContactNumber],[EmailAddress],[EmployeeCode],[Year],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (7,4,2,'Mark Joseph','','Gammad','Bacoor, Cavite 4102','09156675925','mark.joseph.gammad@sissat.com','2008180031',3,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Employees] ([EmployeeId],[EmployeeTypeId],[CourseId],[FirstName],[MiddleName],[LastName],[HomeAddress],[ContactNumber],[EmailAddress],[EmployeeCode],[Year],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (8,4,3,'Havjo','','Anas','Bacoor, Cavite 4102','09053503538','havjo.anas@sissat.com','2008180032',4,1,1,GETDATE(),1,GETDATE());

SET IDENTITY_INSERT [dbo].[Employees] OFF

USE [GradingSystemDb]
SET IDENTITY_INSERT [dbo].[Users] ON

INSERT [dbo].[Users] ([UserId],[EmployeeId],[Username],[Password],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (1,1,'2004180029','password',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Users] ([UserId],[EmployeeId],[Username],[Password],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (2,2,'2004180030','password',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Users] ([UserId],[EmployeeId],[Username],[Password],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (3,3,'2004180031','password',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Users] ([UserId],[EmployeeId],[Username],[Password],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (4,4,'2004180032','password',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Users] ([UserId],[EmployeeId],[Username],[Password],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (5,5,'2008180029','password',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Users] ([UserId],[EmployeeId],[Username],[Password],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (6,6,'2008180030','password',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Users] ([UserId],[EmployeeId],[Username],[Password],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (7,7,'2008180031','password',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Users] ([UserId],[EmployeeId],[Username],[Password],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (8,8,'2008180032','password',1,GETDATE(),1,GETDATE());

SET IDENTITY_INSERT [dbo].[Users] OFF

USE [GradingSystemDb]
SET IDENTITY_INSERT [dbo].[Subjects] ON

INSERT [dbo].[Subjects] ([SubjectId],[Name],[Description],[Code],[Units],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (1,'Algebra','Basic Algebra','ALGB113',3.00,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Subjects] ([SubjectId],[Name],[Description],[Code],[Units],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (2,'Trigonometry','Basic Trigonometry','TRGM113',3.00,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Subjects] ([SubjectId],[Name],[Description],[Code],[Units],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (3,'Filipino I','Prerequisite for Filipino II','FLFB113',3.00,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Subjects] ([SubjectId],[Name],[Description],[Code],[Units],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (4,'English I','Prerequisite for English II','ENGL113',3.00,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Subjects] ([SubjectId],[Name],[Description],[Code],[Units],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (5,'Physics Lecture I','Prerequisite for Physics Lecture II','PHFB113',3.00,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Subjects] ([SubjectId],[Name],[Description],[Code],[Units],[IsActive],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (6,'Physics Laboratory I','Prerequisite for Physics Laboratory II','PHFB111L',1.00,1,1,GETDATE(),1,GETDATE());

SET IDENTITY_INSERT [dbo].[Subjects] OFF

USE [GradingSystemDb]
SET IDENTITY_INSERT [dbo].[Schedules] ON

INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (1,3,1,'Rm309','MWF','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 07:30:00 AM','15-Jul-11 09:00:00 AM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (2,3,1,'Rm311','MWF','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 09:00:00 AM','15-Jul-11 10:30:00 AM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (3,3,2,'Rm307','MWF','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 01:30:00 PM','15-Jul-11 03:00:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (4,3,1,'Rm309','MWF','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 04:30:00 PM','15-Jul-11 06:00:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (5,3,2,'Rm309','MWF','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 07:30:00 PM','15-Jul-11 09:00:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (6,3,2,'Rm309','TThS','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 10:30:00 AM','15-Jul-11 12:00:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (7,3,1,'Rm301','TThS','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 01:30:00 PM','15-Jul-11 03:00:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (8,3,2,'Rm302','TThS','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 03:00:00 PM','15-Jul-11 04:30:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (9,3,2,'Rm302','TThS','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 06:00:00 PM','15-Jul-11 07:30:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (10,3,1,'Rm311','MWF','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 07:30:00 AM','15-Nov-11 09:00:00 AM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (11,3,1,'Rm311','MWF','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 09:00:00 AM','15-Nov-11 10:30:00 AM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (12,3,2,'Rm302','MWF','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 01:30:00 PM','15-Nov-11 03:00:00 PM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (13,3,1,'Rm311','MWF','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 04:30:00 PM','15-Nov-11 06:00:00 PM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (14,3,2,'Rm313','TThS','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 10:30:00 AM','15-Nov-11 12:00:00 PM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (15,3,1,'Rm301','TThS','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 01:30:00 PM','15-Nov-11 03:00:00 PM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (16,3,2,'Rm304','TThS','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 03:00:00 PM','15-Nov-11 04:30:00 PM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (17,3,2,'Rm308','TThS','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 06:00:00 PM','15-Nov-11 07:30:00 PM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (18,4,3,'Rm107','MWF','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 09:00:00 AM','15-Jul-11 10:30:00 AM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (19,4,3,'Rm107','MWF','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 10:30:00 AM','15-Jul-11 12:00:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (20,4,3,'Rm107','MWF','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 01:30:00 PM','15-Jul-11 03:00:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (21,4,3,'Rm107','MWF','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 03:00:00 PM','15-Jul-11 04:30:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (22,4,4,'Rm112','TThS','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 09:00:00 AM','15-Jul-11 10:30:00 AM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (23,4,4,'Rm112','TThS','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 10:30:00 AM','15-Jul-11 12:00:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (24,4,4,'Rm112','TThS','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 01:30:00 PM','15-Jul-11 03:00:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (25,4,4,'Rm112','TThS','15-Jul-11 00:00:01 AM','15-Nov-11 11:59:59 PM','15-Jul-11 03:00:00 PM','15-Jul-11 04:30:00 PM','1',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (26,4,3,'Rm107','MWF','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 09:00:00 AM','15-Nov-11 10:30:00 AM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (27,4,3,'Rm107','MWF','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 03:00:00 PM','15-Nov-11 04:30:00 PM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (28,4,3,'Rm107','MWF','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 10:30:00 AM','15-Nov-11 12:00:00 PM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (29,4,3,'Rm107','MWF','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 01:30:00 PM','15-Nov-11 3:00:00 PM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (30,4,4,'Rm112','TThS','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 09:00:00 AM','15-Nov-11 10:30:00 AM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (31,4,4,'Rm112','TThS','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 03:00:00 PM','15-Nov-11 04:30:00 PM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (32,4,4,'Rm112','TThS','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 10:30:00 AM','15-Nov-11 12:00:00 PM','2',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Schedules] ([ScheduleId],[EmployeeId],[SubjectId],[RoomNumber],[ScheduleDay],[StartDate],[EndDate],[StartTime],[EndTime],[Semester],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (33,4,4,'Rm112','TThS','15-Nov-11 00:00:01 AM','15-Mar-12 11:59:59 PM','15-Nov-11 01:30:00 PM','15-Nov-11 03:00:00 PM','2',1,GETDATE(),1,GETDATE());

SET IDENTITY_INSERT [dbo].[Schedules] OFF

USE [GradingSystemDb]

INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (5,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (5,3,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (5,21,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (5,22,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (6,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (6,3,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (6,21,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (6,22,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (7,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (7,3,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (7,21,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (7,22,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (8,1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (8,3,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (8,21,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (8,22,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (5,10,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (6,12,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (7,27,1,GETDATE(),1,GETDATE());
INSERT [dbo].[Matriculations] ([EmployeeId],[ScheduleId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (8,30,1,GETDATE(),1,GETDATE());

